Create VCR, MCR, and Shooting Involved by District
Step 1: Create Scatter Plot (choose scatter plot visual)
a. Details = District Name, Xaxis = Violent Crime Rate, Yaxis = Major Crime Rate, Size = Count of Crimes, Tooltips = Shooting Involved Crimes (remove periods from all names)
b. Select formatting, in general X position = 151, Y position = 76, Width = 577, Height = 284
c. Xaxis. Color = custom (1E5A8E), text size = 9, font = Constantia, title color = black, text size = 10, font = Constantia
d. Yaxis, Color = custom (FCB714), text size 9, font = Constantia, title color = black, text size = 10, font = Constantia
e. Data Color = format color, field value, Color Measure
f. Category, Color = black, text size = 8, font = Constantia
g. Color borders on
h. Title, VCR, MCR and Shooting Involved by District, Color = black, background = light gray, alignment = center, text size = 12, font = Constantia
i. Border = light gray
j. Select Analytics (magnifying glass) Create xaxis constant line, value = .1846, Color = custom (1E5A8E)
k. Select Analytics (magnifying glass) Create yaxis constant line, value = .3012, Color = custom (BD890F)
Step 2: Adjust Averages for color measure and Yaxis contstant. Follow GIF below.
Here is a video on creating a scatter plot in Power BI. This may help you get started with creating your own.